create   proc   p_search   
  @str   Nvarchar(1000)   --要搜索的字符串   
  as   
  if   @str   is   null   return   
    
  declare   @s   Nvarchar(4000)   
  create   table   #t(表名   sysname,字段名   sysname)   
    
  declare   tb   cursor   local   for   
  select   s='if   exists(select   1   from   ['+replace(b.name,']',']]')+']   where   ['+a.name+']   like   N''%'+@str+'%'')   
  print   ''所在的表及字段:   ['+b.name+'].['+a.name+']'''   
  from   syscolumns   a   join   sysobjects   b   on   a.id=b.id   
  where   b.xtype='U'   and   a.status>=0   
  and   a.xtype   in(175,239,99,35,231,167)   
  open   tb   
  fetch   next   from   tb   into   @s   
  while   @@fetch_status=0   
  begin   
  exec(@s)   
  fetch   next   from   tb   into   @s   
  end   

 insert into TK_JingJiRenQuDao values ('2ef78680-51a7-4633-bgea-ca4eb5e3k4b4','0','张三')